Week 3

Milestones

• Write ETL to move sync telemetry
• Add audit fields in sync telemetry
• Update ETL for audit fields in sync telemetry
• Start with testing of ETL sync telemetry

Screenshots / Videos

ETL database containing sync telemetry table along with audit fields:

Contributions

• https://github.com/avniproject/avni-server/pull/583
• https://github.com/AvinashRamachandruni/avni-etl/issues/2
• https://github.com/AvinashRamachandruni/avni-server/issues/1

Learnings

• Understood avni-server code in order to add audit fields to it.
• Got to learn new sql functions like COALESCE.
• Understanding how testing is performed in ETL.
• Learnt about Flyway migration